The Macintosh Demo Applications CD/Apple-MacintoshDemoApplicationsCD-1.0-1992.bin/More Information/GQL V3.0/Open ME! - USA Sales/Open ME! - USA Sales.rsrc/gDEM_13258_Order Example

Text File | 1992-01-27 | 253b | 1 lines

select customer.cust_name, customer.cust_city, customer.cust_state, orders.ord_amount from customer, orders where ((customer.cust_state = 'NY') and ((orders.ord_amount > $5000) and (orders.ord_amount < $20000))) and customer.cust_num = orders.cust_nr ;